--- title: Application data model summary: Cross-library database table inventory grouped by domain. status: draft owner: last_reviewed: 2026-08-21 --- # Application data model This page documents the cross-library database table inventory for Claims Legal, grouped by business domain. ## Legal case and scheduling | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | LEGAL_CASE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Master legal case record linked to a claim ([SQL-046](../libraries/saif-business-claim-legal/sql/SQL-046-legalcase.md)–[SQL-050](../libraries/saif-business-claim-legal/sql/SQL-050-legalcase.md), [SQL-051](../libraries/saif-business-claim-legal/sql/SQL-051-legalcasecollection.md)). | | CASE_STATUS_HISTORY | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | Case status change history ([SQL-007](../libraries/saif-business-claim-legal/sql/SQL-007-casestatushistorycollection.md)). | | LEGAL_SCHEDULE / SCHEDULE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Hearing, mediation, deposition, and calendar events ([SQL-040](../libraries/saif-business-claim-legal/sql/SQL-040-legalschedule.md)–[SQL-044](../libraries/saif-business-claim-legal/sql/SQL-044-legalschedule.md), [SQL-045](../libraries/saif-business-claim-legal/sql/SQL-045-legalschedulecollection.md)). | | LEGAL_FILE_LOCATION | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | File location history and current file tracking ([SQL-036](../libraries/saif-business-claim-legal/sql/SQL-036-legalfilelocation.md)–[SQL-039](../libraries/saif-business-claim-legal/sql/SQL-039-legalfilelocation.md)). | | LEGAL_CASE_EVALUATION | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | LCE due-date, filed-date, excusal, and transfer state ([SQL-033](../libraries/saif-business-claim-legal/sql/SQL-033-legalcaseevaluation.md)–[SQL-035](../libraries/saif-business-claim-legal/sql/SQL-035-legalcaseevaluation.md)). | | CONSOLIDATED_CASE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRU | Primary-to-secondary legal-case linkage used for propagation workflows ([SQL-056](../libraries/saif-business-claim-legal/sql/SQL-056-consolidations.md), [SQL-057](../libraries/saif-business-claim-legal/sql/SQL-057-consolidations.md)); see [BR-APP-003](business-rules.md#br-app-003-consolidated-case-state-propagation). | ## Appeals and outcomes | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | APPEAL | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Appeal header and level-specific data ([SQL-009](../libraries/saif-business-claim-legal/sql/SQL-009-appeal.md)–[SQL-012](../libraries/saif-business-claim-legal/sql/SQL-012-appeal.md), [SQL-013](../libraries/saif-business-claim-legal/sql/SQL-013-appealcollection.md)). | | APPEAL_EXTENSION | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | Approved extension tracking for appeals ([SQL-014](../libraries/saif-business-claim-legal/sql/SQL-014-appealextension.md), [SQL-015](../libraries/saif-business-claim-legal/sql/SQL-015-appealextension.md)). | | CASE_OUTCOME | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Outcome or order header for a case ([SQL-020](../libraries/saif-business-claim-legal/sql/SQL-020-caseoutcomecollection.md)–[SQL-023](../libraries/saif-business-claim-legal/sql/SQL-023-caseoutcome.md)). | | OUTCOME_ISSUE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | Outcome-level issue, grounds, body-part, and fee detail ([SQL-024](../libraries/saif-business-claim-legal/sql/SQL-024-outcomeissue.md), [SQL-025](../libraries/saif-business-claim-legal/sql/SQL-025-outcomeissue.md)). | | OUTCOME_STAFF | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | ALJ, board-member, or staff linkage to an outcome ([SQL-026](../libraries/saif-business-claim-legal/sql/SQL-026-outcomestaff.md), [SQL-027](../libraries/saif-business-claim-legal/sql/SQL-027-outcomestaff.md)). | ## Requests, acknowledgements, costs, and other parties | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | REQUEST_ISSUE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | Requested issue rows for a legal case ([SQL-028](../libraries/saif-business-claim-legal/sql/SQL-028-requestissue.md), [SQL-029](../libraries/saif-business-claim-legal/sql/SQL-029-requestissue.md)). | | CASE_COST | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Legal cost, billing, authorization, and cancellation tracking ([SQL-001](../libraries/saif-business-claim-legal/sql/SQL-001-casecost.md)–[SQL-004](../libraries/saif-business-claim-legal/sql/SQL-004-casecost.md), [SQL-006](../libraries/saif-business-claim-legal/sql/SQL-006-casecostcollection.md)). | | ACKNOWLEDGE workflow procedure set | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRU | WCB or DCBS acknowledgement updates ([SQL-008](../libraries/saif-business-claim-legal/sql/SQL-008-acknowledge.md)). | | LEGAL_CASE_EMPLOYER | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CR | Employer, insurer, and attorney-party linkage for a case. | | LEGAL.vw_cases | LEGAL | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Case-number lookup used by letter generation support. | ## Assignment and reference data | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | ATTORNEY_CONFLICT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Attorney conflict maintenance ([SQL-065-104](../libraries/saif-business-claim-legal/sql/SQL-065-104-attorneyconflict,.md)). | | ATTORNEY_POLICY_ASSIGNMENT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Policy-to-attorney assignment maintenance. | | ATTORNEY_SCHEDULE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Attorney schedule and time-off maintenance. | | ATTORNEY_WORKER_ASSIGNMENT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Worker-to-attorney assignment rules. | | OUT_OF_TOWN_ROTATION_ASSGN | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Rotation assignment maintenance. | | HEARING_LOCATION | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Hearing location lookup and maintenance ([SQL-062](../libraries/saif-business-claim-legal/sql/SQL-062-hearinglocation.md), [SQL-063](../libraries/saif-business-claim-legal/sql/SQL-063-hearinglocation.md)). | | LEGAL_PERSON and LEGAL_PERSON_TYPE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Legal person master data and role classification ([SQL-061](../libraries/saif-business-claim-legal/sql/SQL-061-legalperson.md)). | | OTHER_FIRM | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | CRUD | Outside firm and employer reference data ([SQL-064](../libraries/saif-business-claim-legal/sql/SQL-064-otherfirm.md)); note the SQL-injection tech debt finding on `clsOtherFirm.ValidateState` in [Tech debt](tech-debt.md). | ## Policy context and access | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | POLICY | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Policy header and policy-list lookup data. | | POLICY_PERIOD and POLICY_PERIOD_NON_WCIS | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md), [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Policy-period and ownership-period context. | | TRADING_AS | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Trading-name records for policy display. | | NON_EMPR_ACCT | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Non-employer account lookup. | | BUSINESS_AFFILIATE and AFFILIATE | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Officer-of-notice and affiliation lookups. | | ASSOCIATION_TYPE_CODE | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Association-type metadata that drives policy-header association retrieval. | | PA_AUDIT, PA_AUDITOR, and PA_POLICY_PERIOD | [unqualified]** | [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) | R | Auditor-access and last-audit lookups. | ## Shared policy reference and rating support | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | HAZARD_GROUP | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Hazard-group reference data. | | BENEFIT_JURISDICTION_CODE | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Benefit-jurisdiction code map. | | MANUAL_CLASS_TYPE_CODE | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Manual-class-type code map. | | ENDORSEMENT | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Information-page and endorsement status lookup support. | | PREM_HIST_SUMMARY | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Premium-history set resolution for rating support. | ## Batch and document support | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | submit_appworx_job | [unqualified]** | [SAIF.Services.Appworx](../libraries/saif-services-appworx/overview.md) | C | Batch letter and print-job submission procedure. | | xprint_control_seq | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | RU | Sequence used by create-file document numbering support ([SQL-052](../libraries/saif-business-claim-legal/sql/SQL-052-createfile.md), [SQL-053](../libraries/saif-business-claim-legal/sql/SQL-053-createfile.md)). | ## Related documentation - [Application index](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Configuration](configuration.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [Security and authorization](security-authorization.md) - [Tech debt](tech-debt.md) > **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified. ## Sources - `SAIF.Business.Claim.Legal/clsLegalCase.vb` - `SAIF.Business.Claim.Legal/clsCaseCost.vb` - `SAIF.Business.Claim.Legal/clsAppeal.vb` - `SAIF.Business.Claim.Legal/clsCaseOutcome.vb` - `SAIF.Business.Claim.Legal/clsAssignmentProcess.vb` - `SAIF.Business.View.Policy/clsPolicyData.vb` - `SAIF.Business.Policy/PolicyInformation.vb` - `SAIF.Services.Appworx/AppworxServices.vb`